Kelly P.
Kelly P.
Reactions
-
Re: How to trigger dropdown to populate projected completed date based on specific complexity?
@NBKD Make sure that both the "Record Date: Complexity" and "Projected Complexity Completion" columns are Date columns.1 · -
Re: If function based on multiple columns
@Maz Uddin It's easiest and cleanest to write the formula backwards (in this case, from the rightmost to the leftmost). Try this: =IF([Column5]@row = "Yes", "C Approved", IF([Colu…1 · -
Re: Copy row Automation not working when triggered by a Vlookup field
@Lisa Bagshaw As the first article below states, you can't trigger an automation from a cross-sheet formula. You could use a time-based workflow instead though (second article below). Hope this helps!1 · -
Re: Edit reports on a dashboard
@Marc Shecter One workaround that I have used in the past is to use the Web Content widget on the dashboard in conjunction with the embed code option in the publish settings of the sheet (edit by any…4 · -
Re: If or Index or Match....not sure what to use
@JSpears You'd want to use an index/match formula. Try this: =INDEX({SourceSheet_DocuSignStatus}, MATCH([Go-Live Checklist by Area]@row, {SourceSheet_Area}, 0)) Hope this helps!1 ·
